* define libraries;
libname ben '/projects/users/########/Snapshot2022/IntermediateData';

proc import out = ben.plants_csm_2022 
  datafile = "/projects/users/########/Snapshot2022/IntermediateData/PlantLevelWindDatabase2022.dta"
  dbms=dta
  replace;
run;

data ben.plants_csm_2022;
  set ben.plants_csm_2022;
  stfips = substr(t_fips,1,2);
run;

data ben.plants_csm_2022_23;
  set ben.plants_csm_2022;
  where stfips = "01" or stfips = "04" or stfips = "05" or stfips = "06"
      or stfips = "08" or stfips = "10" or stfips = "11" or stfips = "17"
      or stfips = "18" or stfips = "19" or stfips = "20" or stfips = "23"
      or stfips = "24" or stfips = "29" or stfips = "30" or stfips = "31"
      or stfips = "32" or stfips = "35" or stfips = "38" or stfips = "40"
      or stfips = "47" or stfips = "51" or stfips = "56";
run;
